Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$GES_BLOCKING_ENQUEUE

This Real Application Clusters view describes all locks currently known to lock manager that are being blocked or blocking others. The output of this view is a subset of the output from `V$GES_ENQUEUE`.

See Also: "V$GES_ENQUEUE" for a description of all locks known to the lock manager

Column | Datatype | Description
--- | --- | ---
`HANDLE` | `RAW(4 | 8)` | Lock pointer
`GRANT_LEVEL` | `VARCHAR2(9)` | Granted level of the lock
`REQUEST_LEVEL` | `VARCHAR2(9)` | Requested level of the lock
`RESOURCE_NAME1` | `VARCHAR2(30)` | Resource name for the lock
`RESOURCE_NAME2` | `VARCHAR2(30)` | Resource name for the lock
`PID` | `NUMBER` | Process identifier which holds the lock
`TRANSACTION_ID0` | `NUMBER` | Lower 4 bytes of the transaction identifier where the lock belongs to
`TRANSACTION_ID1` | `NUMBER` | Upper 4 bytes of the transaction identifier where the lock belongs to
`GROUP_ID` | `NUMBER` | Group identifier for the lock
`OPEN_OPT_DEADLOCK` | `NUMBER` | `1` if `DEADLOCK` open option is set, otherwise `0`
`OPEN_OPT_PERSISTENT` | `NUMBER` | `1` if `PERSISTENT` open option is set, otherwise `0`
`OPEN_OPT_PROCESS_OWNED` | `NUMBER` | `1` if `PROCESS_OWNED` open option is set, otherwise `0`
`OPEN_OPT_NO_XID` | `NUMBER` | `1` if `NO_XID` open option is set, otherwise `0`
`CONVERT_OPT_GETVALUE` | `NUMBER` | `1` if `GETVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_PUTVALUE` | `NUMBER` | `1` if `PUTVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_NOVALUE` | `NUMBER` | `1` if `NOVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_DUBVALUE` | `NUMBER` | `1` if `DUBVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_NOQUEUE` | `NUMBER` | `1` if `NOQUEUE` convert option is set, otherwise `0`
`CONVERT_OPT_EXPRESS` | `NUMBER` | `1` if `EXPRESS` convert option is set, otherwise `0`
`CONVERT_OPT_NODEADLOCKWAIT` | `NUMBER` | `1` if `NODEADLOCKWAIT` convert option is set, otherwise `0`
`CONVERT_OPT_NODEADLOCKBLOCK` | `NUMBER` | `1` if `NODEADLOCKBLOCK` convert option is set, otherwise `0`
`WHICH_QUEUE` | `NUMBER` | Which queue the lock is currently located. `0` for NULL queue; `1` for GRANTED queue; `2` for CONVERT queue.
`STATE` | `VARCHAR2(64)` | State of lock as owner sees it
`AST_EVENT0` | `NUMBER` | Last AST event
`OWNER_NODE` | `NUMBER` | Node identifier
`BLOCKED` | `NUMBER` | `1` if this lock request is blocked by others, otherwise `0`
`BLOCKER` | `NUMBER` | `1` if this lock is blocking others, otherwise `0`